Line and stacked column Visual 17
Visual 4: Line and stacked column Visual =: Deaths Per Mth /%YoY,
%MoM by Interaction Groups
Fields Tab
For step 1
·
Shared Axis: Interaction Group
·
Column Values: Deaths per Mth
·
Line Values: %YoY, %MoM
Format
Tab
·
General: X Position = 757, Y Position =
410, Width = 515, Height = 294
·
Maintain layer order = off
Step 2
Legend:
On, Position = Top, Title = on, Color = #00000, font family = Segoe Ui, Text size = 10,
Style = Markers Only, Match line color = on, circle defaut icon = on
X
Axis: Color = #7777777,
Text Size = 9, Font family = Segoe UI, Minimum category width = 20, Maximum
Size = 25%, Inner Padding = 20%, Concatenate labels = On, Title = Off
Y
Axis: Position = Left, Scale Type = Linear, start = Auto, End = Auto, Invert
Axis = off, Color = #000000,
Text size = 9, Font family = Segoe UI, Display Units = Auto, Value Decimal
places = Auto, Title = Off,
Grid line = on, Line color
= #CCCCCC, Strok width = 1, Line style = Doted, Show secondary = on, Aline zeros = off
Step 3
Zoom Slider = off
Data
Colors, YoY%
= #E1A204, MoM = #33DBFF,
Show all = off, (Color = #000000)
Data Label = On, Color = #000000, Display
Units = Auto, Value Decimal places = 2, Orientation = Horizontal, Position =
Auto, Text Size = 9, Font Family = DIN, Show Background = on, Background color = #FFFFFF, Transparency = 0%, Customize
series = off
Shapes: Shade area = On, Stroke width = 3,
Join Type = Round, Line Style = Solid, show marker = off, stepped = off,
customize series = off,
Plot
Area:
Transparency = 50%
Step 4
Title = On, Text = By Interaction
Group, Title Heading = Heading 3; Word wrap = On, font color = #FFFFFF, Background color = #000000, Alignment = Center, Text Size = 15, Font Family = Segoe UI
Background: On, color = #FFFFFF, Transparency
= 0%
Lock
Aspect
= off
Border: off
Shadow: Off
Tooltip = On, Type = Report
Page, Page = Auto, Label Text color = #000000, Value text color = #EAEAEA, Text size = 9,
Font family = Segoe UI, Background color = #333333, Transparency = 5%
Visual
header
= On, background color = #FFFFFF, Boarder = #FFFFFF, Transparency = 0%, Icon
color = #333333, Visual information icon = On, Visual warning icon = On, Visual
error icon = on, Drill on drop down = On, Drill up icon = On, Drill down icon =
On, Show next level icon = On, Expand to next level icon = On, Expand to next
level icon = on, Pin icon = On, Focus mode icon = On, Filter icon = On, See
data layout icon = On, More Options icon = On, Visual Header tooltip icon = off
Step 5
Select
“Filter” From “View” menu then in Filter click “Interaction Group” then select
the following Interaction Group type::
Use the following step by step Gif to create the visual
For step 1
For step 2
For step 3
For step 4
For step 5
Line and Stacked Column Chart in Power BI
https://www.tutorialgateway.org/line-and-stacked-column-chart-in-power-bi/